i want write query within th Age field

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

select t1.Gender,t1.Religion,t1.Caste,t1.Age,t3.Image
from Ushadi as t1
inner join RshiHabit as t3
on t3.FId=t1.Id

Respected Sir,

I want to use ""select Age from Ushadi where Age between @minage and @maxage"" this statement query within t1.Age field like;

select t1.Gender,t1.Religion,t1.Caste,t1.Age(select Age from Ushadi where Age between @minage and @maxage),t3.Image
from Ushadi as t1
inner join RshiHabit as t3
on t3.FId=t1.Id

how should i use this qyery within t1.Age?

plz reply...

Posted 5-Jan-13 0:36am

Member 9432818

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Answer 1 · 2013-01-05T00:49:00

Solution 1

if you want to fetch records having age between range then write query as beow...

SQL

select t1.Gender,t1.Religion,t1.Caste,t1.Age,t3.Image
from Ushadi as t1
inner join RshiHabit as t3 on t3.FId=t1.Id
where
t1.Age between @minage and @maxage

Happy Coding!
:)

Posted 5-Jan-13 0:49am

Aarti Meswania

i want write query within th Age field

1 solution

Solution 1

Add your solution here

Preview 0

i want write query within th Age field

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us