Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by PWNr00t
-
MySQL PHP UNION JOIN LEFT RIGHT WHAT??
actualy that probaby would have worked nicely but i dont have MySQL 4 installed i tryed to install it today and ran into all sorts of issues this is a production machine and i dont want kill it i looked at a howto on geting around union with left join it seems the examples dont really ever fit... -
MySQL PHP UNION JOIN LEFT RIGHT WHAT??
I need assistance with a select statement so far i have this "SELECT table1.lastname as ln1, table1.firstname as fn1, table2.lastnameas ln2, table2.firstname as fn2 FROM table1, table2 ORDER BY ln1, ln2"; which produces this ln1 fn1 ln2 fn2 lastname firstname lastname firstname...
