The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
mysql troubles with left joins
ok im trying to figure out a way to compare a table to another to find rows that no longer have a parent. similar to orphan thread but my only problem is that the column names are different but hold the same data. so the USE() function isnt possible and i do not think ON() will work because it will only find the rows that do coinside with table 1 from table 2. basically i want find journals that no longer have journalists and remove them.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|