Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2003
    Posts
    3

    Unanswered: what join should i use

    I have 5 tables that i need to query identified by a statusid,
    i want to grab all the rows that have the statusid of 1 now my problem is that im a newbie to joins. Ive read and read but most examples are confusing to me.

    here is the db structure simplified

    table customer
    cid
    name
    statusid

    table orders
    orderid
    statusid
    total

    table info
    infoid
    statusid

    table hosting
    hostingid
    statusid
    hostingname

    table status
    statusid
    remarks
    feedback

    so i want to grab all the rows in all 5 tables that contain the statusid of 1

    what would be the best route to do this?

    Last edited by sherdog; 08-07-03 at 22:52.

Posting Permissions

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