how can I use data relationship or join tables -

I want join to tables from an index field then I want to collecting field form both tables. Also, I want to place those field into a grid, in another words I want to place some field into text boxes and another fields into a grid. How can I do that. here is an example of my code.

FROM table1 JOING table2 ON table1.customer = table2.orders;

I am tired trying this but it does not work in my collection, I will apreciate your help

MS Access - LEFT JOIN syntax in many to many relationship -
Hi all I need help with the syntax for creating a LEFT JOIN query in MS Access (in many-to-many relationship situation) that would retrieve all the records from my first table, even if no records existed in the second table (ie. return empty fields if there is no data). If only two

data relations -
say for example in SQL we have a relationship of 2 tables. Now, we fill a dataset with both these tables - I know the relationship does not automatically get created but instead we would add the relationship using a DataRelation - that's all cool. Would I be correct in saying that

how can I use data relationship or join tables -
I want join to tables from an index field then I want to collecting field form both tables. Also, I want to place those field into a grid, in another words I want to place some field into text boxes and another fields into a grid. How can I do that. here is an example of my code. F

Set relationship in SQL Table -
Hi, I'm using the SQL server 2005 and have about 10 tables and all the relationships are already set. So does it means in my vb6 application, I don't have to do those inner / outer join in the SQL statements when I retreive the recordset from the SQL tables? Is that the right way

***RESOLVED***SQL Query - Join Multiple Tables -
I know how to join two tables.... but i was wondering if it possible to join several tables together, ie 2 or more tables. This is because i need data from related tables in a single recordset so i can put the relevant info on a form, keep it in sync. I have tried but i get a 'Sy

Join between tables -
earlier i was using foxpro and in that for e.g. i had 2 tables with the common field as sc_code, on which i set a relationship between the tables. and when i move a record in the main table, simultaneously the record pointer moves to the corresponding record in the other table. and if

Access relationship -
I have more than one database and I want to know the relationship between tables(relationship name,relationship type...etc) in each one from VB. So please help I have to hand this project next week.

Bind to a relationship -
Hello, I have a dataset with two tables. There is a parent child relationship between the tables. I have succesfully bound some form controls to the child table. However I also want to bind other controls to the parent table. While searching I found that you can (or should be able t

Extract relationship from sql server... -
Hi, I have a problem.... I am connect with adodb with sql server. In this data base i have many tables, and all tables have a Primary Key, a Foreign Key and they are relationship. How I do for extract the relationship between tables and their Key (if they are primary or foreign ke

Question about Join / TB relationship -
Hi, I have two tables, one table ontains 20 records with customer id and have other tables with 3000 records which is the customer master file, Join two tables together by the customer ID fields (simple enough) then when check the first table ,the no of records are increased fro

one to many in vb.net - sql server -
I have two tables customers and orders(in MS Server2000) that have a one to many relationship.I just want to represent this relationship on the vb.net form say, one customer with several orders.The relationship had already been defined at the database level as usual.But my concern is w

Mixing of JOIN and others -
i have a a few tables that need to be joined from a 'central' table. i use in-line sql: select a,b,c,d FROM central table JOIN a_T on... JOIN b_T on...and so on... However i have som

[2003] Join 2 tables! -
hey there! need to join 2 tables to been displayed on a datagrid the filling part is no problem the part that im getting stuck is in the sql query where the join has to be done. got table A and table B, the join that i want to do is to display all the info of both tables all the

query and retrieve data from diff. tables -
Hello, The user supplies the name and the class and i need to show him all the data from 10 different tables matching the name and class. I try and find out the stdId matching the stdName and stdClass from tables studentPersonal and studentAcademic then when i have the stdId I join (o

ADO and Relationship -
Hello How important is to create a relationship between two tables in access before creating a connection in Visual basic using ADO. the reason i ask is that if the tables are connected already in access. whenever you want to add data on the many side of the table and only the p

How to set tables having primary-foriegn key, while coding -
Hi all, you all have given me great help, i am thankful for that. I have another prob. I am trying to add around 20 tables from database. some tables have primary-foreign key [one to many] relationship. while adding table containing ONE-TO-MANY relationship, compiler gives e

[Access 2003] Relationship Name Length -
I am working on some linked tables and am having a problem when I try to set up the relationships between some of them, the error that I am getting is that the relationship name is too long, the two table names combine to a name of more than 64 characters in length. Given that

Distributted Application -
Hi, Do you know how to build a Distributted Application in 3 tiers? Do you have an example about this? Could you please tell me how to code the business entity and data entity? what is the relationship each other? I should build one class for one table or not? If I build a class for

Query with join -
Hello, The user supplies the name and the class and i need to show him all the data from 10 different tables matching the name and class. I try and find out the stdId matching the stdName and stdClass from tables studentPersonal and studentAcademic then when i have the stdId I join al

Left Outer Join on Dataset -
I have a dataset "dsCustOrd" with 2 tables "tblCustomers" and "tblOrders" with an established relationship between the 2 tables. I need to query the dataset to give me all Customers that have no orders. I knnow a left outer join will do it but haveno i

Multiple Table Join -
I am currently trying to join all 4 tables together in one single sql statement. The tables are like A -> B -> C -> D having the key of D, sql statement should give a result of related records of D key. I;ve tried using statement below by i get some syntax error.

Hiding/sizing columns in data grid -
I have a data grid that is bound to a relationship of two tables in a dataset. The common field in the relationship is classId. When I view the data in the data grid I do not want to see the classId field but if I do not include the field in my select statement I get an error when I

Join Two Tables -
I haev two tables in Access 2000, with the same type of data in them. Table1 ID, Name, Company Table2 ID, Name, Company I would like to join this two tables in a query like this: Query1 Name, Company Is this posible? Tahnks

[2005] sql join & typed dataset -
I have a typed dataset generated by VS2005 for my sqlServer 2005 DB. All is great when using with queries & stored procedures (SP) that only work with one table. But I would like to include SP's that return data from many tables using inner joins. This is where the type dataset

linking two access tables -
We have connected to an Access database that consists of two tables. We have a one to many relationship between the tables. We are trying to display and navigate through all the records of both tables through an SQL statement. However, when we execute the SQL, only one table is able

Importing tables with relationship -
When importing tables from Access/Oracle to SQL Server, how can I import tables with relationship as well?

Joining tables and Updating -
I'm trying to join two tables from Access in a datagrid developed in VB 6.0. I can update on of the tables involved in the JOIN by clicking on the datagrid and editing it. However, I cannot edit the other table in the JOIN through the datagrid. IS there any way around this? Any hel

ado and multiple databases -
I'm trying to connect to several different data sources. It's possible to write a sql query to join tables in different databases, or even different servers for that matter. But an ado connection to sql specifies one database. How then would you join tables? With dbase you can spe

Best Way to do Child Parent / Join in ADO -
Okay, got an app I'm creating and I need data from two different tables to display and be editable on the same page. This has been a real pain for me for some reason. Anyway I want to know the best way to do this. Currently I have a Shape command populating all the textboxes, but it se

Moving Data from One Access Table to another -
I have two tables in an MS Access database and the tables have a one to many relationship. The data in TableCurrentLog is the Parent table (the one in the relationship)has the Primary Key, LogNumber. The data in TableCurrentLogProgressions has multiple instances of the LogNumber and

Using SQL to add a relationship with 2 (or more) tables. -
Hi, I use the server explorer in vb.net to create the SQL-databases. I want to join 2 tables, lets name them 'tblPerson' and 'tblScills'. I want to create a one-to-many relationship. I want to use these 2 tables, in combination with a dataset, sqlDatadapter,etc etc, to crea

what's the proper way to do this (db relationship) -
Hello guys, What's the proper, normalized way to "join" tables from a design point of view? The same table with the purchase detail that points to the main table n times (one for each product selected)? or a relationship table that links both tables? Having three tab

[02/03] Join tables frm different connections -
Hi all, I have 2 tables frm 2 difference datasources. One in my access database and the other is an XLS file. I want to join these 2 tables based on a common field. How shall I go for it? Regards, Prakash

Problem with one to many relationship -
Using VB.NET and SQL server,I have a one to many relationship between two tables ie member and transactions.I just want to link these tables and display the records accordingly.Parent table details should be displayed on the windows form and child table details should be displayed o

join 2 tables or open a rs -
I have a big table with around 50 columns. I've to upload it to a SQL Server 6.5 and then write an asp page to search the records. Since SQL 6.5 has a limit on the length of a row, I've to vertically partition my table into 2. These two tables have exactly the same number of records a

Joins and Unions -
Hello All, I'm attempting to display data from two tables. Here is the relationship of the two tables: Table NODE.NODE_ID = SEGMENT.NODE_FROM_FK OR = SEGMENT.NODE_TO_FK The node_id can either equal the node_from_fk or it can equal the node_to_fk but

Relationship viewing with ADO -
Hi, im still new to ADO and got this problem I have two tables that have a relationship with each other Now in VB i have listed the main table in a listbox ( well a listview but im keeping things simple ) Now i want to be able to click on a record in the listbox and in another

Realy complex SQL relationships question -
Due to choices beyond my control I am faced with a tough bit of SQL to compose. I have four tables. Let us callt hem A, B, C & D. Table B has had it's content wholesale copied into table A. Table A is dynamic and changes table B will never change. Table B has a non expli

Build relationship with VBA -
Can anyone tell me if it is possible to build a relationship between 2 tables in VBA or do I always have to create a relationship in the dersigner ?