I have tried the join syntax and all but I can't do what
mytable1 has a field myname and I put a name "abc" in it.
mytable2 has a field myname and I put a name "xyz" in it.
SELECT * FROM mytable1,mytable2;
myname | myname
abc | xyz
But I want it this way:
Is that possible through simple syntax? That is, Mysql just think
that those two tables are actually one?
I tried straight_join, cross join, and tried all examples in "JOIN"
docs... but nothing helped me.
Any suggestions guyz? (perhaps a GROUP BY on columns?)
I am not on the list, please email me directly.
Faisal Nasim (the Whiz Kid)
FAX: (815) 846-2877