Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Many to Many query
Name: ShaqDiesel Date: July 3, 2008 at 21:24:51 Pacific OS: winXP CPU/Ram: Amd64/1Gb Product: custom
Comment:
I have a many to many relationship of titles and authors. I have a table of authors, another for titles, and a junction table. For a given title, how would I extract ALL the authors? I don't want multiple rows for the same title.
Name: dotnet_ohio Date: July 16, 2008 at 19:38:05 Pacific
Reply:
It depends on your database. I am not 100% sure on MySQL, but in Access or SQL 200x you can use a left join / right join command in the from clause. The left join (and there are forums - just search google for left join / right join) that will tell you the exact details.
Also, a trick I used to do was link the tables in Access. Then in the actually do the query with the design view in access. After you make the join between the tables, just select all from table titles to table authors. If you click over to the SQL view, it will actually create the query for you. Note, you can't just cut and paste this as is, you will have to format it for whatever language you have. Also, I'm not sure if this will work with MySQL.
Summary: Hi, I want to edit a query in Access using batch file. I am trying to edit a field[jobID] based on criteria. I want to open the query in design view and then edit it. Can anyone please help me with...
Summary: I would like to know how to optimize this SQL to let my server load faster and take low usage? I need to calculate the radius distance for a US ZIP Code to get the result, such as 50 miles from a part...
Summary: In the database window you shyould see Tables, Queries, Forms etc. Click Queries -> "Create new query in Design View", add both of your tables (the key fields should link for you) You should see two b...