CODEWITHSUNDEEP
c#databasems-access
filipeff12
filipeff12

Reputation: 27

working with multiple tables

I have a c# project where I am using a MS access database, and I am trying to put some items from two (related) tables, in the same listView.

This is the code that I have:

Where it sais "none" is the place where I want to put an item from the other table, but i don't know how. Since they have a relationship I thought that was possible to call items from one table or another.

Please note that I am fairly new to c# and working with databases.

Upvotes: 0

Views: 60

Answers (4)

Blaargon
Blaargon

Reputation: 88

Try altering your query to include this information. Something like:

  Select FirstName, LastName, ColumnFromOtherTable, CellPhone, ClientsT.ClientID 
from ClientsT, OtherTable where ClientsT.ClientID=OtherTable.ClientID

Of course, in order to do this, you have to have a corresponding ID field in both tables.

Upvotes: 0

Litisqe Kumar
Litisqe Kumar

Reputation: 2564

select FirstName,LastName,(select none from SecondTable where Clients.Field= SecondTable.Field),CellPhone,ClientID from Clients

Upvotes: 0

Patrick Hofman
Patrick Hofman

Reputation: 156918

You should join the two tables together to get the unified result.

You could do something like this:

select c.*
,      s.otherFieldYouNeed
from   ClientsT c
join   SomeOtherTable s
on     c.someId = s.someId

Upvotes: 2

apomene
apomene

Reputation: 14389

since the two table are related you can use a join query to get the desired result:

select FirstName,LastName,'none',CellPhone,ClientID from Clients inner join mySecondTable

on Clients.mysharedField=mySecondTable.mysharedField

Upvotes: 1

Related Questions