Database

test-09 wrote:

Now i need to search columns from 5 tables How can i do it....

select projectID=projects.projectid,projectname,
[image],country,county,ClientCompany,city,ConstructionCompletionDate_dt,
OverallBuildingSize_uts from projects, schedule,BuildingSiteStatics 
where projects.projectid=schedule.projectid and projects.projectid=BuildingSiteStatics.projectid

FROM dbo.FactConsoTB AS F
  INNER JOIN dbo.Branch AS B ON F.BranchID = B.BranchID
  INNER JOIN dbo.lnkAccountProduct AS L ON F.APLinkID = L.APLinkID
  INNER JOIN dbo.Account AS A ON L.AccountID = A.AccountID
  INNER JOIN dbo.Product AS P ON L.ProductID = P.ProductID
  INNER JOIN dbo.Currency AS C ON F.CurrencyID = C.CurrencyID
  INNER JOIN dbo.Currency AS BC ON F.BaseCurrencyID = BC.CurrencyID
  INNER JOIN dbo.ProductCategory ON P.ProductCategoryID = dbo.ProductCategory.ProductCategoryID

test-09 wrote:

select projectID=projects.projectid

SELECT     dbo.Projects.ProjectID, dbo.Projects.ProjectName,
 dbo.Projects.City, dbo.Projects.County, dbo.Projects.Country,
 dbo.Projects.ClientCompany, 
                      dbo.BuildingSiteStatics.OverallBuildingSize_uts, 
dbo.Schedule.ConstructionCompletionDate_dt, 
dbo.OverallDevelopment.TotalNumberDwellings

FROM         dbo.Projects INNER JOIN
                      dbo.BuildingSiteStatics ON dbo.Projects.ProjectID = dbo.BuildingSiteStatics.ProjectID INNER JOIN

                      dbo.OverallDevelopment ON dbo.Projects.ProjectID
 = dbo.OverallDevelopment.ProjectID INNER JOIN

                      dbo.Schedule ON dbo.Projects.ProjectID = dbo.Schedule.ProjectID where projectname like '%%' or country like ''
 or clientcompany like '%%' or ConstructionCompletionDate_dt like '%%'

test-09 wrote:

Now i need to search columns from 5 tables How can i do it....

I are Troll

Vuyiswa Maseko wrote:

Challenge

Vuyiswa Maseko wrote:

This is a Project i inherited

create table family_relatives (
	relative_id	integer primary key,
	spouse		references family_relatives,
	mother		references family_relatives,
	father		references family_relatives,
	-- in case they don't know the exact birthdate
	birthyear	integer,
	birthday	date,
	-- sadly, not everyone is still with us
	deathyear	integer,
	first_names	varchar(100) not null,
	last_name	varchar(100) not null,
	sex		char(1) check (sex in ('m','f')),
	-- note the use of multi-column check constraints
	check ( birthyear is not null or birthday is not null)
);