Hi, just after a bit of advice on programming style.... I have one main table which holds keys to records in other tables. There is also an additional table that uses the main tables ID field as a key. I need to generate a view that joins data from each of these tables. Should this be achieved through a series of separate "Selects" (dealing with two tables at a time) or is it more appropriate (possible?) to use a single statement? Table 1 ID field field 1 field 2 Key1 Key2 Table 2 Key1 Field 1 Table 3 Key2 Field 1 Table 4 ID ID (from Table 1) Field 1 Thanks in anticipation, Marcus --------------------------------------------------------------------- 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
