in Education by
SELECT TOP (1) Ordreliste.OrdreID, Ordreliste.KundeID, Ordreliste.OrdreDato, Ordreliste.Navn, Ordreliste.Farve FROM Ordreliste INNER JOIN Kundeliste ON Ordreliste.KundeID = Kundeliste.KundeID ORDER BY Ordreliste.OrdreDato DESC I need a simple method to get customer name, address and so on from kundeliste and can it be put into the existing method?? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
Is this what you are looking for ? SELECT TOP (1) Ordreliste.OrdreID, Ordreliste.KundeID, Ordreliste.OrdreDato, Ordreliste.Navn, Ordreliste.Farve, Kundeliste.CustomerName, Kundeliste.CustomerAddress FROM Ordreliste INNER JOIN Kundeliste ON Ordreliste.KundeID = Kundeliste.KundeID ORDER BY Ordreliste.OrdreDato DESC If you are lookng to get customer name and customer address from Kundeliste table, where Joining condition meets, then you simply just needs to mention the column names in the select clause.

Related questions

0 votes
    SELECT TOP (1) Ordreliste.OrdreID, Ordreliste.KundeID, Ordreliste.OrdreDato, Ordreliste.Navn, Ordreliste.Farve FROM ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 7, 2022 in Education by JackTerrance
0 votes
    I know that the name of the user account can be retrieved from the built in variable User!UserID but ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 15, 2022 in Education by JackTerrance
0 votes
    I ran into an issue when installing Team Foundation Server 2008 Workgroup Edition. I have a Windows Server ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    I ran into an issue when installing Team Foundation Server 2008 Workgroup Edition. I have a Windows Server ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    For some reason, when I try to install SQL Server 2008 Express, I get an error saying that I need ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 21, 2022 in Education by JackTerrance
0 votes
    For some reason, when I try to install SQL Server 2008 Express, I get an error saying that I need ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 21, 2022 in Education by JackTerrance
0 votes
    I'm trying to do a SQL Server 2008 setup and I've been given a Cross Language Installation failure ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    I'm trying to do a SQL Server 2008 setup and I've been given a Cross Language Installation failure ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    As of SQL Server 2005, you used to be able to open a flat file in SQL Management Studio off the ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 7, 2022 in Education by JackTerrance
0 votes
    As of SQL Server 2005, you used to be able to open a flat file in SQL Management Studio off the ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 6, 2022 in Education by JackTerrance
0 votes
    Here is my test SQL: declare @Table table (strField nvarchar(6), xmlField xml) insert into @Table values ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 23, 2022 in Education by JackTerrance
0 votes
    Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    I have tried and tried, and can not get linked. I can connect to the server using SSMS, but can not link to ... = '[password]' GO Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    To use a Simple Network Management System, we need _______. A. Protocols B. Rules A. IP B. Servers...
asked Feb 14, 2023 in Technology by JackTerrance
0 votes
    How many coefficients do you need to estimate in a simple linear regression model (One independent variable)? (a) ... of R Programming Select the correct answer from above options...
asked Feb 12, 2022 in Education by JackTerrance
...