Inner Join

[sade]

I have two tables, table a and table b.
I do :

select *
from a 
inner join b
on b.some = a.something
where b.another = somevalue

How can I put another WHERE to sort my data but for an attribute from table a.
When I put it after the last WHERE it doesn't bring me any results.

Thanks

[r035198x]

I have two tables, table a and table b.
I do :

select *
from a
inner join b
on b.some = a.something
where b.another = somevalue

How can I put another WHERE to sort my data but for an attribute from table a.
When I put it after the last WHERE it doesn't bring me any results.

Thanks

Can you post the query that didn't work?
You only put one where and separate the conditions with an and if you want to add additional filtering. For sorting you use order by not a where clause.

[mwasif]

Elboratingr 035198x's answer with examples

If you want to add another WHERE condition, simply add AND and the condition

select * from a 
inner join b
on b.some = a.something
where b.another = somevalue
AND a.comecolumn = 'some value'

This is the answer to your adding order by (sorting the results)

select * from a 
inner join b
on b.some = a.something
where b.another = somevalue
ORDER BY a.somecolumn

But still we want to see which query you have tried.

[sade]

SELECT * Person.FullName, Person.BirthDate, Person.Address 
FROM Partners
INNER JOIN Person 
ON Person.PartnerID = Partners.Customer and Person.BirthDate > '1980-10-05' 
where Partners.Producer = '158'

That's the query. If I don't use the last line (where Partners.Producer = '158'), it returns me results. But when I use a last where for any property of table Partners, the query just runs and runs... no results.
Thank you for your time.

[r035198x]

SELECT * Person.FullName, Person.BirthDate, Person.Address
FROM Partners
INNER JOIN Person
ON Person.PartnerID = Partners.Customer and Person.BirthDate > '1980-10-05'
where Partners.Producer = '158'

That's the query. If I don't use the last line (where Partners.Producer = '158'), it returns me results. But when I use a last where for any property of table Partners, the query just runs and runs... no results.
Thank you for your time.

I suppose you have read the responses given above?

[sade]

Thanks for your quick responses.
I am trying the way, you told me, but it doesn't work.
Maybe it's a database problem.

[mwasif]

Kinldy use appropriate code tags when posting code/syntax. Please follow this site's Posting Guidelines when posting questions or answers.

[mwasif]

You can not write the query like

SELECT * Person.FullName, Person.BirthDate...

You must have to use comma to separate column names in the SELECT.

SELECT *, Person.FullName, Person.BirthDate...

You can write your query as below too (I have moved Person.BirthDate > '1980-10-05' to WHERE clause)

SELECT * FROM Partners
INNER JOIN Person 
ON Person.PartnerID = Partners.Customer 
WHERE Person.BirthDate > '1980-10-05' AND Partners.Producer = '158'

Make sure you have the records where Producer = '158' and the date is greater than '1980-10-05'.

[sade]

Because of many records I have in the database, it takes too long to bring results and most times it just crashes.
Question can be closed.
Thank you for your answers and your time.

[mwasif]

Because of many records I have in the database, it takes too long to bring results and most times it just crashes.

Consider optmizing your query by creating indexes on Person.BirthDate and Partners.Producer. This will definetly reduce your query time.