Re: [SQL] How do I extract ONE particular field, when multiple table

[Patrik Kudo]

What you want to know is probably this:

Select XID, xi.DENOM, PRICE, FRT, CTID From XItem xi, Category c Where
 xi.System=1 and xi.Category=c.Index

Regards,
Patrik Kudo


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])