What Am I Doing Wrong

[dannyd]

select a.clientname, c.catlabel
from clientsegueads a product_adcategories b product_categories c 
WHERE b.catid 
IN (select c.catid from product_categories where c.cadid = "493")
 LIMIT 3;

clientsegueads
----------------------
cadid
clientname

product_adcategories (bridge table)
--------------------------------
cadid
cat_id

product_categories
----------------------------
cat_id
cat_label

any clues what im donig wrong ?

[pbmods]

Heya, Danny. Welcome to TSDN!

Please use CODE tags when posting source code:

[CODE=MySQL]
MySQL code goes here.
[/CODE]

What's your code doing that you don't want it to? I bought an ESP helmet last month, but it's still on backorder....

[amitpatel66]

select a.clientname, c.catlabel
from clientsegueads a product_adcategories b product_categories c 
WHERE b.catid 
IN (select c.catid from product_categories where c.cadid = "493")
 LIMIT 3;

clientsegueads
----------------------
cadid
clientname

product_adcategories (bridge table)
--------------------------------
cadid
cat_id

product_categories
----------------------------
cat_id
cat_label

any clues what im donig wrong ?

IS it becuase you are using a Double Quotes in subquery instead of single quotes?? Try using single Quotes then POST back if this was the problem

[r035198x]

select a.clientname, c.catlabel
from clientsegueads a product_adcategories b product_categories c 
WHERE b.catid 
IN (select c.catid from product_categories where c.cadid = "493")
 LIMIT 3;

clientsegueads
----------------------
cadid
clientname

product_adcategories (bridge table)
--------------------------------
cadid
cat_id

product_categories
----------------------------
cat_id
cat_label

any clues what im donig wrong ?

You are also missing some commas in

 from clientsegueads a, product_adcategories b, product_categories c