Michael Knauf/Niles wrote: >I get 7 rows of data I don't want, then the 7 rows of data I do want... and >after scratching my head for awhile, I've come to the conclusion that I do >not understand the query structure. (the query came from multiple >suggestions in response to my last posting on this list, so clearly it >makes sense to some of you...) > > Well, you seem to be getting what you asked for ... in your SQL QUERY ... but if its not what you wanted, then describe what you _really_ want, not what you think the query will look like;
If you mean: "I want the various spec outputs for a product called 'fg00914'", then you probably just want to ask for the specs stuff and products stuff seperately, since there's only one product (correct?) and multiple specs (correct?). SELECT * FROM products WHERE fg_number = "fg00914"; - returns one line SELECT * FROM specs WHERE fg_number = "fg00914"; - returns 7 lines? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- 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
