Results 1 to 2 of 2

Thread: Query help pls

  1. #1
    Join Date
    Mar 2012
    Posts
    27

    Unanswered: Query help pls

    Hi All,

    I have two tables: Oracle sql

    Table customer( userid username, date_oftrans) -- (20,000 rows)

    Table cust_info( userid keyid, balance) -- (59,000,000,000 rows)

    I want all the customers with their relevant info attached. How do i write the query so that it uses a join between table Customer and Cust_info so all the records from Customer re retrieved along with the relevant cust_info?

    this is what I have so far..

    Select a.Userid, a.Username,a. date, b.keyid, b.balance
    from customer a, Cust_info b
    where a.userid=b.userid
    group by
    a.Userid, a.Username, a. date, b.keyid, b.balance

    Would this retrieve the 20,000 records with there relevant details??

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by Unknownuser View Post
    Hi All,


    Would this retrieve the 20,000 records with there relevant details??
    here's a radical thought:-

    why not try it and see what (if anything happens)

    is this a MySQL question or an Oracle question?
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •