更正此查询... [英] Correct this Query...............

问题描述

select d.VehNo,d.Place,d.Status1,d.Note,t.TDate,t.TFrom,t.Tto,t.Party,t.Km,t.Goods,t.Quantity,t.Unit,t.Rate,t.Type1,t.FAmt,t.Rcv,t.RcvBy,t.RcnNo,t.Balance,t.TLoad,t.TUnload from DailyStatus as d join TempTrip as t where d.VehNo=t.Vehno

请检查纠正它..........

Plz check & correct it..........

推荐答案

哇，你真是太粗鲁了.但是由于今天我心情愉快，我会为您修复它.

Wow, you are simply so RUDE. But as I am in a good mood today, I''ll fix it for you.

SELECT
    d.VehNo,
    d.Place,
    d.Status1,
    d.Note,
    t.TDate,
    t.TFrom,
    t.Tto,
    t.Party,
    t.Km,
    t.Goods,
    t.Quantity,
    t.Unit,
    t.Rate,
    t.Type1,
    t.FAmt,
    t.Rcv,
    t.RcvBy,
    t.RcnNo,
    t.Balance,
    t.TLoad,
    t.TUnload
FROM
    DailyStatus as d INNER JOIN TempTrip as t ON
        d.VehNo = t.Vehno

最好阅读加入基本知识 [

Better, read the JOIN fundamentals[^] as your query was''t only incorrect. It also did not make any sense.

与运算符LEFT/RIGHT一起使用JOIN:

USE JOIN with operator LEFT/RIGHT:

SELECT d.*, t.*
FROM DailyStatus as d LEFT JOIN TempTrip as t ON d.VehNo=t.Vehno

SELECT d.*，t.*
FROM DailyStatus为d，TempTrip为t ON d.VehNo = t.Vehno


我们也可以使用它.

右/左连接取决于他们的需要.

SELECT d.*, t.*
FROM DailyStatus as d,TempTrip as t ON d.VehNo=t.Vehno


WE can use this also.

Right/Left join depends upon their need.

这篇关于更正此查询...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！