Sorry about my last email which was long and not clear.
This is what I want to do
Join two tables on "code table1" = "code table3" where messageid = for
example 28
table 1 contains :
message from messageid
--
message1 |
Hello, I'm trying to get what is for me quite a complicated query to
work, if it's possible to do so anyway ...
Here is my old query :
SELECT a.message,a.date,b.surname,b.name,b.title FROM messages a JOIN
info b ON a.from=b.code WHERE a.id='28'
It worked fine untill I needed to have more than on
Hi...
I have a situation where I want to periodically copy new rows from a source
database/tables on a remote server. Using a cron process, I'm looking to
periodically copy the new tbl/rows into the dest database on my local
server.
i don't want to get into implementing slave/master replication,
In my experience, having a limit of a particular number of anythings per
something, eg. components per compound word is always a mistake, whether it's
the number of payments allowed to pay an invoice, the number of children per
parent, the number of cars per family, pets per owner, etc. There's
Hi;
I'm going to build a translation s/w and I'd like some advice. Many
languages have compound words. I'd like to build a table that shows the
component words. However, it depends on the compound word as to how many
components it has! Now, I could take a "safe" guess and limit it to, say, 4
words.
Garris, Nicole wrote:
Is id a sequential number? And is it referenced by other tables? If
so, and if over time new products become "old" products, then CASE 2
is more complex, because when moving a product (i.e., a row) from the
new product table to the old product table, the value of id needs to
