Self Join Table Form Development
The field in the table are:
strID (Primary Key)
I think it will require a two form approach, one to create the employee and one to assign the boss. But I want the boss to be a combo box with only employees that have been created.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I can force an entry into each table - but that seems a bit crude (I.e add a record for every new entry in my main table into the 10 child tables - but this seems to be a waste - I only want to join tables when there is info in them - when I am doing this I can join two tables fine - but adding another one where there is no data FK seems to throw it. I will have about 10-12 tables to join.
Table 1 - contains a whole range of names
Table 2 - contains ONLY some of the names ON TABLE 1
I created an inner join between the names on both of these table as I need the amounts from tble 1 with the names of table 2
Is it possible to also get a list of names and amounts from table 1 which DO NOT APPEAR IN TABLE 2
this was code used to find the similar names on tbl 2 with amounts from tbl1
SELECT tbl2name, tbl1Amount
FROM list2 INNER JOIN list1 ON tbl2name = tbl1name;
I've done this before only catch is now I need to use a where clause which removes the non-matching rows.
As you know, in order to join database tables, they must have a field in common. The fields on which you join tables must be the same or compatible data types and they must contain the same kind of data, however they do not have to have the same field name (although they probably will).
Occasionally, the two database tables that you want to bring the data from may not have a field in common and you will have to add another table to the query with the sole purpose of joining the tables.
I have 4 table and each table have 3 columns each. All Tables have ID as their primary key.
Here's the table names and columns (a, b , c are column names)
Tab1 - ID, a, b
Tab2 - ID, c, d
Tab3 - ID, e, f
Tab4 - ID, g, h
I need to change the order of columns in retrieved data should this order ID, a, h, c,g,b,d, e, f
Can Order by statement can be use with Table joining?
I can join 2 tables but, I need to join all 4. Not only that I need the exact order (not the ID, a ,b, c, d, e, f, g, h order)
Using Order by is the biggest problem I have.
This type of relationship does not exist between multiple database tables, it is actually a relationship that exists between the records within a single database table.
Consider the scenario where all of the data you require is contained within a single table, but you may need to be able to relate columns within that table to each other to extract the desired data. Usual examples of this type of data relate to Employee information, where the table may have both an Employee's ID number for each record and also a field that displays the ID number of an Employee's supervisor or manager.
To retrieve the data you need to be able to relate the data to itself. For this purpose the Self-Join is designed to do exactly this action.
The tables which l cannot join are company and fleet data and management vehicles subform table.
I don't mind how the two tables are joined as long as l can create records without any problems and then create a query to link which combines the two.