cara delete tabel make inner join

Beranda
Komunitas
Tech
Programmer Forum
cara delete tabel make inner join

mejikusupplier

28-05-2013 04:01

cara delete tabel make inner join

halo agan2 saya mau tanya dong kalau cara delete table yg make inner join bgmn ya
ane bikin store procedurenya kaya gini gan yg untuk select nya

Spoiler for SP select:

Quote:

SELECT dbo.studentGrade.studentID, dbo.student.studentName, dbo.studentGradeProj.lvName, dbo.wsOut.wsOutDate, dbo.studentGrade.wsID, dbo.studentGrade.majorID,
dbo.studentGrade.levelID,wsOut.wsOutID
FROM dbo.studentGrade INNER JOIN
dbo.wsOut ON dbo.studentGrade.studentID = dbo.wsOut.studentId AND dbo.studentGrade.majorID = dbo.wsOut.majorID AND
dbo.studentGrade.levelID = dbo.wsOut.levelID AND dbo.studentGrade.wsID = dbo.wsOut.wsID INNER JOIN
dbo.studentGradeProj ON dbo.studentGrade.studentID = dbo.studentGradeProj.studentID AND dbo.wsOut.majorID = dbo.studentGradeProj.majorID INNER JOIN
dbo.student ON dbo.studentGrade.studentID = dbo.student.studentID

Spoiler for ini yg dh di select:

nah ane itu mau delete satu rows aj gan misalkan

rows ini gan:
10294 JESSIE Z 6A 2013-01-10 12:45:17.010 041-050 3 4 292

bagaimana cara buat query y

tolong pencerahannya gan

2.6K

Kutip

Balasan

Komentar yang asik ya

Urutan

Terbaru

Terlama

Komentar yang asik ya

Komunitas Pilihan