How do I create table data based on a query?

[onedaywhen]

I'm not sure about the UNIQUE bit

I assumed a business rule of only one senator per district. In my
country, a constituency is defined as the area represented by one
Member of Parliament (or is it vice versa? told you I was ignorant of

I'm sympathetic to your desire for specifics.

Is their a way to have access spit out SQL code (other than in the
query dialogues).

I don't think so. I have a pet project that takes an OLEDB/ODBC source
(e.g. MS Access/Jet, Excel, SQL Server, text file, etc), interrogates
its schema and spits out a script for the basic CREATE TABLEs followed
by any ALTER TABLE..ADD CONSTRAINTs, using (fairly) standard SQL
(recreating the data using INSERT INTOs is on my 'to do' list). I'm
sure it's a common pet project so perhaps someone has made one
available online...?

Jamie.

--

 

[cleabn21]

Thanks Ken, I managed to attach meaning to that SQL, though syntatically it
would have been a struggle to conjure that on my own.

Having tried it, is their a way to extract a list of District.DistricID from
the query? I'm looking to for a list of Districts where their is match
between Senators and Members.

 

[weiwei]

Thanks Ken, I managed to attach meaning to that SQL, though syntatically it
would have been a struggle to conjure that on my own.

Having tried it, is their a way to extract a list of District.DistricID from
the query? I'm looking to for a list of Districts where their is match
between Senators and Members.