salut...am si eu o problema cu un script de select
am 3 tabele
CREATE TABLE [dbo].[Judet] (
[id_judet] [int] IDENTITY (10, 10) NOT NULL ,
[id_tara] [int] NOT NULL ,
[nume_judet] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[asezare] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Localitate] (
[id_loc] [int] IDENTITY (100, 3) NOT NULL ,
[id_judet] [int] NOT NULL ,
[nume_loc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[nr_locuitori] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tara] (
[id_tara] [int] IDENTITY (1, 1) NOT NULL ,
[nume_tara] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[latitudine] [int] NOT NULL ,
[longitudine] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Judet] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[id_judet]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Localitate] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[id_loc]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Tara] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[id_tara]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Judet] ADD
CONSTRAINT [fk_tara] FOREIGN KEY
(
[id_tara]
) REFERENCES [dbo].[Tara] (
[id_tara]
)
GO
ALTER TABLE [dbo].[Localitate] ADD
CONSTRAINT [fk_judet] FOREIGN KEY
(
[id_judet]
) REFERENCES [dbo].[Judet] (
[id_judet]
)
GO
as dori sa fac un select care sa-mi intoarca tara,nume_judet,localitate al localitatilor cu cel mai mare numar de locuitori
multumesc mult