The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
Need help with a query
Here it is
[sql]SELECT * FROM post WHERE userid = 1 AND postid IN SELECT reviewids from product where productid = 3 [/sql] The product table has a field called reviewids which is a list of reviewsids in this format 980,1020,2212 I know I can execute a single query to grab the ids and a second query to make this check (which should return true or false), but I'd rather do it in one query if I can. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|