Use leftjoin
hello experts.
I have two queries and want to use only one.
Any help?
will this speed up the process?
firstquery:
SELECT ItemID, ProductID
FROM products
WHERE itemid = 45
secondquery:
SELECT taxrate
from taxes
WHERE defaulttax = 1
AND product_type_id = firstquery.productid
I have two queries and want to use only one.
Any help?
will this speed up the process?
firstquery:
SELECT ItemID, ProductID
FROM products
WHERE itemid = 45
secondquery:
SELECT taxrate
from taxes
WHERE defaulttax = 1
AND product_type_id = firstquery.productid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
regards
panos