bas60
Posts: 18
|
Posted: 09/13/2011, 9:12 AM |
|
I need to access info from several files
I have this as my datasource.... only problem is the where bit does not seem to work!!
select * from products
inner join manufacturers on products.manufacturer_id = manufacturers.manufacturer_id
inner join category on products.category_id = category.category_id
where products.machine_id=machine_id
I get the same result (multiple rows from my products file...
I want only one - the one with the machine_id
is my syntax correct ??
Can anyone help??
|
|
|
mamboBROWN
Posts: 1713
|
Posted: 09/20/2011, 8:30 PM |
|
bas60,
Something does not seem right about the query. Have you tried running this query directly in MySQL to see if it gives you what you want?
|
|
|
|