I would like to know if it is possible, to select certain columns from one table, and another column from a second table, which would relate to a non imported column in the first table. I have to obtain this data from access, and do not know if this is possible with Access, or SQL in general.
How do I define table relations in a circular reference?
Is there a standard way to duplicate a row in a database table?
SQL: sum 3 columns when one column has a null value?
You could use the following:.
CREATE TABLE tbl_1 ( pk_1 int, field_1 varchar(25), field_2 varchar(25) ); CREATE TABLE tbl_2 ( pk_2 int, fk_1 int, field_3 varchar(25), field_4 varchar(25) );
Teradata locks - How to know if a table is locked?
In regard to Bill's post, there are two ways to create JOIN's within SQL queries:.
SELECT t1.field_1, t2.field_3 FROM tbl_1 t1 INNER JOIN tbl_2 t2 ON t1.pk_1 = t2.fk_1 WHERE t2.field_3 = "Some String"
SQL Server 2000 - How to find out what indexes are in use?
- Implicit - The join is created using the WHERE clause of the query with multiple tables being specified in the FROM clause.
EWS - import email into sql database
- Explicit - The join is created using the appropriate type of JOIN clause (INNER, LEFT, RIGHT, FULL).
Article compatibilty in SQL database
How can I efficiently do a database massive update?
. For example, if you later add an explicit join to a query that already uses an implicit join with multiple tables referenced in the FROM clause, the first table referenced in the FROM clause will not be visible to the explicitly joined table..
You are only importing some columns.
You want to build a query which references a column which you haven't imported.. If this is true, it's just not possible.
As far as the Access query engine in concerned the non-imported columns don't exist.. Why not just import them as well?.