No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
4 Posted Topics
 | How are the four tables related? Are there primary keys / foreign key relationships between the tables. |
| | Re: MS Sql help Hi Are the four tables related in any way? Is there a primary key / foreign key relationship between the tables... If not you could try the following: [CODE] SELECT INTO New_Table table1.a, table1.b, table2.g, table3.j, table3.k, table4.n, table4.p FROM table1, table2, table3, table4 [/CODE] If the tables are related … |
| | Hi folks I need some help! I have two tables the first contains account information, and the second contains flags that records in the account table may have. These are joined by the account?id. One account record may have several flags from the flag table. ie the following select select … |
| | Hi, Have you tried using the group by clause ie Select count (*) as total, country_name from your_table_name group by country_name |
The End.