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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.