Hi,
I am doing a select from to tables which are join'ed, I cannot determine
automatically which table a column belongs to:-
I have tried both these selects:-
SELECT * FROM staff, staffsubjectTitles WHERE staff.id = 11 AND
staffsubjectTitles.staff_id = 11
SELECT staff.*, staffsubjectTitles.* FROM staff, staffsubjectTitles
WHERE staff.id = 11 AND staffsubjectTitles.staff_id = 11
But both give me:-
name is TYPE 12
uid is TYPE 12
id is TYPE 4
departmentTitles_id is TYPE 4
jobTitles_id is TYPE 4
taAdmin is TYPE 1
studentAdmin is TYPE 1
groupBSD_id is TYPE 4
taUser is TYPE 1
staffAdmin is TYPE 1
keyroll_id is TYPE 4
doesReports is TYPE 1
homeEmail is TYPE 12
id is TYPE 4
staff_id is TYPE 4
subjectTitles_id is TYPE 4
What I am hoping to get is:-
staff.name is TYPE 12
staff.uid is TYPE 12
staff.id is TYPE 4
staff.departmentTitles_id is TYPE 4
staff.jobTitles_id is TYPE 4
staff.taAdmin is TYPE 1
staff.studentAdmin is TYPE 1
staff.groupBSD_id is TYPE 4
staff.taUser is TYPE 1
staff.staffAdmin is TYPE 1
staff.keyroll_id is TYPE 4
staff.doesReports is TYPE 1
staff.homeEmail is TYPE 12
staffsubjectTitles.id is TYPE 4
staffsubjectTitles.staff_id is TYPE 4
staffsubjectTitles.subjectTitles_id is TYPE 4
This is what I use to display the results (Perl):-
for ( $i = 1 ; $i <= $sth->{NUM_OF_FIELDS} ; $i++ ) {
print "$sth->{NAME}->[$i-1] is TYPE $sth->{TYPE}->[$i-1] <br>\n";
}
Unfortunately I left my O'reilly mySql & perl dbi book at work.
M.
--
He came from Econet - Oh no, I've run out of underpants :(
Home:- [EMAIL PROTECTED] http://www.wizdom.org.uk
Shadow:- [EMAIL PROTECTED] http://www.shadow.org.uk
Work:- [EMAIL PROTECTED] http://www.hinwick.demon.co.uk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
