Help !

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have 2 tables. Table Application and table Connections ( with columns
Application, and Application2)

Example :
Table Connections

Appication Application2
Geneva Siebel
Geneva Tibco
ISOM Geneva

Table Application

ID Application Version ...
1 Geneva
2 Siebel
3 Tibco


I try to make the follow query :

SELECT Connections.Application, Connections.Application2
FROM (Application INNER JOIN Connections ON Application.ID =
Connections.Appl1)
WHERE (((Application.Application) Like ("*" & [Enter Application] & "*")))
OR (((Connections.Appl2) Like ("*" & [Enter Application] & "*")));

if enter Geneva for Applicatin name on search criteria.

This query show this result :

Application Application2
Geneva Siebel
Geneva Tibco

But doesn't show the last row where Geneva also Exist.

ISOM Geneva

How to modify the query to get the desire result?

Please Help me with this !

Tnanks !
 
SELECT Application, Application2
FROM Connections
WHERE ((Application Like ("*" & [Enter Application] & "*"))
OR (Application2 Like ("*" & [Enter Application] & "*")));

Peter said:
Hi,

I have 2 tables. Table Application and table Connections ( with columns
Application, and Application2)

Example :
Table Connections

Appication Application2
Geneva Siebel
Geneva Tibco
ISOM Geneva

Table Application

ID Application Version ...
1 Geneva
2 Siebel
3 Tibco

I try to make the follow query :

SELECT Connections.Application, Connections.Application2
FROM (Application INNER JOIN Connections ON Application.ID =
Connections.Appl1)
WHERE (((Application.Application) Like ("*" & [Enter Application] & "*")))
OR (((Connections.Appl2) Like ("*" & [Enter Application] & "*")));

if enter Geneva for Applicatin name on search criteria.

This query show this result :

Application Application2
Geneva Siebel
Geneva Tibco

But doesn't show the last row where Geneva also Exist.

ISOM Geneva

How to modify the query to get the desire result?

Please Help me with this !

Tnanks !
Click to expand...
 
This doesn't work properly !!!

kingston via AccessMonster.com said:
SELECT Application, Application2
FROM Connections
WHERE ((Application Like ("*" & [Enter Application] & "*"))
OR (Application2 Like ("*" & [Enter Application] & "*")));

Peter said:
Hi,

I have 2 tables. Table Application and table Connections ( with columns
Application, and Application2)

Example :
Table Connections

Appication Application2
Geneva Siebel
Geneva Tibco
ISOM Geneva

Table Application

ID Application Version ...
1 Geneva
2 Siebel
3 Tibco

I try to make the follow query :

SELECT Connections.Application, Connections.Application2
FROM (Application INNER JOIN Connections ON Application.ID =
Connections.Appl1)
WHERE (((Application.Application) Like ("*" & [Enter Application] & "*")))
OR (((Connections.Appl2) Like ("*" & [Enter Application] & "*")));

if enter Geneva for Applicatin name on search criteria.

This query show this result :

Application Application2
Geneva Siebel
Geneva Tibco

But doesn't show the last row where Geneva also Exist.

ISOM Geneva

How to modify the query to get the desire result?

Please Help me with this !

Tnanks !
Click to expand...
Click to expand...
 
This doesn't work properly !!!

I already try this but , because columns Application and Application2 are
lookup fields to the other table Application this search works only if you
put Appl ID number when you search .
I want to search by name of the Application like Geneva or Siebel , not by
numbers 1 or 2 !!!
kingston via AccessMonster.com said:
SELECT Application, Application2
FROM Connections
WHERE ((Application Like ("*" & [Enter Application] & "*"))
OR (Application2 Like ("*" & [Enter Application] & "*")));
Click to expand...
Click to expand...
 
I think you need table Application in the query two times so you can link it
to the Connections table on the two fields. The SQL would probably look
something like the following.

SELECT A1.Application
, A2.Application
FROM (Application as A1 INNER JOIN Connections
ON A1.ID = Connections.App11) INNER JOIN Application as A2
ON A2.ID = Connections.Appl2
WHERE A1.Application Like "*" & [Enter Application] & "*"
OR A2.Application Like "*" & [Enter Application] & "*"
 
I'm sorry. I missed the part where you said you were using IDs in the table
Connections. Try this:

SELECT Application.Application, Application_1.Application
FROM Application AS Application_1 INNER JOIN (Application INNER JOIN
Connections ON Application.ID = Connections.Application) ON Application_1.ID
= Connections.Application2
WHERE ((Application.Application Like ("*" & [Enter Application] & "*")) OR
(Application_1.Application Like ("*" & [Enter Application] & "*")));

I am unsure of the actual table and field names so you'll need to check them.

Peter said:
This doesn't work properly !!!

I already try this but , because columns Application and Application2 are
lookup fields to the other table Application this search works only if you
put Appl ID number when you search .
I want to search by name of the Application like Geneva or Siebel , not by
numbers 1 or 2 !!!
SELECT Application, Application2
FROM Connections
WHERE ((Application Like ("*" & [Enter Application] & "*"))
OR (Application2 Like ("*" & [Enter Application] & "*")));
Click to expand...
Click to expand...
Click to expand...
 
Back
Top