[cfaussie] Re: Query

Fri, 15 Apr 2005 16:54:19 -0700 

Hi Bjorn,

If all you want is BrandName and ProductName then

SELECT products.NAME as ProdName, brands.NAME as BrandName
  FROM products, brands
 WHERE products.MENU_SUBCAT_ID = #Flash.Param1#
   AND brands.BRAND_ID = products.BRAND_ID

Should do what you want.

Regards,

Brett
B)

Bjorn Schultheiss wrote: 
I know I already gave you guys praise, but that sql statement didn't work
for me

Heres want I want to achieve
Below are the tables, I stripped out most of the fields

CREATE TABLE products (
  PRODUCT_ID int(6),
  MENU_SUBCAT_ID tinyint(4),
  BRAND_ID int(4),
  NAME varchar(50),
  PRIMARY KEY  (PRODUCT_ID)
)
CREATE TABLE brands (
  BRAND_ID int(4),
  NAME varchar(50),
  PRIMARY KEY  (BRAND_ID)
)

My param I'm passing from Flash relates to products.MENU_SUBCAT_ID

SELECT products.NAME as ProdName, products.BRAND_ID, brands.NAME as
BrandName FROM products, brands WHERE products.BRAND_ID = brands.BRAND_ID AND products.MENU_SUBCAT_ID = #Flash.Param1#

I need a result like
BrandName, ProdName;
I-mate   , smartphone;

Guys this is killing me 


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/


--
Brett Payne-Rhodes
Eaglehawk Computing
t: +61 (0)8 9371-0471
f: +61 (0)8 9371-0470
m: +61 (0)414 371 047
e: [EMAIL PROTECTED]
w: www.ehc.net.au

---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

Reply via email to