Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. duffyciaran

    Select common records from 3 tables

    Hi Mufasa, I'm just running this query on an Oracle database where I'm getting a "[Error Code: 907, SQL State: 42000] ORA-00907: missing right parenthesis" error. I think this has something to do with the AS keyword but not sure. I was testing this on a MySQL DB previously and it worked fine...
  2. duffyciaran

    Select common records from 3 tables

    Thanks a million Mufasa - worked perfectly ;-) You're a legend!
  3. duffyciaran

    Select common records from 3 tables

    Hi Mufasa, This is just an example of a larger problem but the relevent columns are as follows: CUSTOMER: customerID PRODUCT: productID customerID shopID SHOP: shopID
  4. duffyciaran

    Select common records from 3 tables

    Hi - I'm trying to construct a select statement from the following tables(see example) _________________________________ |Customer | Product | Shop | |----------|----------|---------| | | | | |Customer1 | Milk | Dairy | | | | | |Customer2 | Cream | Dairy |...

Part and Inventory Search

Back
Top