Click here to Skip to main content
15,867,325 members
Home / Discussions / Database
   

Database

 
QuestionAbout Delphi 11 Professional Edition Pin
Member 1543566318-Nov-21 2:52
Member 1543566318-Nov-21 2:52 
AnswerRe: About Delphi 11 Professional Edition Pin
#realJSOP24-Nov-21 23:49
mve#realJSOP24-Nov-21 23:49 
AnswerRe: About Delphi 11 Professional Edition Pin
Eddy Vluggen6-Dec-21 9:04
professionalEddy Vluggen6-Dec-21 9:04 
AnswerRe: About Delphi 11 Professional Edition Pin
0x01AA6-Jan-22 9:34
mve0x01AA6-Jan-22 9:34 
QuestionConnecting DB tables Pin
MekaC31-Oct-21 20:48
MekaC31-Oct-21 20:48 
AnswerRe: Connecting DB tables Pin
David Mujica1-Nov-21 3:28
David Mujica1-Nov-21 3:28 
GeneralRe: Connecting DB tables Pin
MekaC1-Nov-21 15:59
MekaC1-Nov-21 15:59 
AnswerRe: Connecting DB tables Pin
Member 153296131-Nov-21 3:53
Member 153296131-Nov-21 3:53 
MekaC wrote:
How do I go about doing this?
There is no way for anyone to tell you without seeing your tables. However, a generic answer is like this.

SQL
SELECT table1.*, table2.*  -- select everything from table1 and table2
FROM table1 
INNER JOIN table2 ON table1.field1 = table2.field1 -- here you put what 2 columns (at least) match the tables.




MekaC wrote:
I have tables with different names and none match.
If no tables match then you can't connect them with your login code, but why would you want to anyway?

I don't think you are using the right words to expain youself.
GeneralRe: Connecting DB tables Pin
MekaC1-Nov-21 16:00
MekaC1-Nov-21 16:00 
GeneralRe: Connecting DB tables Pin
Member 153296132-Nov-21 1:09
Member 153296132-Nov-21 1:09 
GeneralRe: Connecting DB tables Pin
MekaC1-Nov-21 15:59
MekaC1-Nov-21 15:59 
GeneralRe: Connecting DB tables Pin
Richard MacCutchan1-Nov-21 22:46
mveRichard MacCutchan1-Nov-21 22:46 
SuggestionRe: Connecting DB tables Pin
CHill602-Nov-21 0:05
mveCHill602-Nov-21 0:05 
AnswerRe: Connecting DB tables Pin
Eddy Vluggen12-Nov-21 12:02
professionalEddy Vluggen12-Nov-21 12:02 
QuestionHow much difference is there between SQL server 2008 and 2012 Pin
jkirkerx28-Oct-21 9:09
professionaljkirkerx28-Oct-21 9:09 
AnswerRe: How much difference is there between SQL server 2008 and 2012 Pin
phil.o28-Oct-21 9:35
professionalphil.o28-Oct-21 9:35 
GeneralRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx28-Oct-21 9:43
professionaljkirkerx28-Oct-21 9:43 
GeneralRe: How much difference is there between SQL server 2008 and 2012 Pin
phil.o28-Oct-21 9:58
professionalphil.o28-Oct-21 9:58 
GeneralRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx28-Oct-21 10:09
professionaljkirkerx28-Oct-21 10:09 
QuestionRe: How much difference is there between SQL server 2008 and 2012 Pin
CHill602-Nov-21 0:10
mveCHill602-Nov-21 0:10 
AnswerRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx2-Nov-21 7:45
professionaljkirkerx2-Nov-21 7:45 
QuestionArray Issue Pin
MekaC24-Oct-21 17:59
MekaC24-Oct-21 17:59 
AnswerRe: Array Issue Pin
Richard Deeming24-Oct-21 22:05
mveRichard Deeming24-Oct-21 22:05 
GeneralRe: Array Issue Pin
MekaC25-Oct-21 11:13
MekaC25-Oct-21 11:13 
AnswerRe: Array Issue Pin
Richard MacCutchan24-Oct-21 22:07
mveRichard MacCutchan24-Oct-21 22:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.