Function der vælger recorrdset i to tabeller

I think you need to explain in a bit more detail what it is you want. If you can give an example it may help too.

med mysql bruger du bare : SELECT LEFT(navn, 4) as navn * from billeder;

Den smider de 4 sidste cifre af... så

varebillede1.gif bliver til
varebillede1


så joiner du bare på de 2

Der skulle gerne  oprette en ny tabel med  to felter.  felt1 = varenummer fra  tabellen import  og  felt2 = navn fra tabellen billeder  hvor varenummer er = navn  da varnummer er lig  med navn bort set fra at der står .gif bag ved

men er det mysql ?

Select billeder.navn, import.varenummer from billeder, import where LEFT(billeder.navn, 4) =  import.varenummer;

ala noget i den stil

Det lyder  meget godt men jeg ville gene have en til at skrive Function for det er jeg ikke for stiv i men eller tak for jeres hurtige svar

jokkejensen> We have to assume that jubas wants to do this in Access as we are in Access category. If this assumption is incorrect then I hope jubas tells us!

jubas> Are you saying that if you have a record in your table and the field varenummer contains for example "Vare123", then you want to create a field in a new table where the field name is Vare123?

If this is correct then I have to ask why? If your table contained say 1000 records, then this would mean that you want 1000 fields in a new table and that is just for varenummer!
So I would try solving your problem in another way, as this is against all the rules of relational databases!

Hej terry du må undskylde at jeg ikke har regeret før nu men har været uden bys
Jeg prøver igen at forklare hvad det er jeg har brug for: jeg skal bruge en  Function der læser alle recorrdset i en tabel og opretter et nyt recorrdset  minus de fire sidste tegn :( varenummer:12215566.gif til nyt felt1:12215566)i samme tabel eller i en ny tabel

This SQL (example) will remove the last four characters from the text in the field varenummer

UPDATE YourTable SET varenummer = Left(VareNummer, Len(VareNummer)-4)

If you want to make a new field in the table then first add the new field in the table and then use

UPDATE YourTable SET YourNewField = Left(VareNummer, Len(VareNummer)-4)


NOTE: This SQL assumes that ALL records contain something in the field Varenummer and that it is longer than 4 characters.

hej terry når jeg bruger din SQL sætninger bliver felt varenummer  tomt hvorfor?

Hi jubas>Hard to say why the field is empty, can you send me your dB so that I can take a look?

eksperten@NOSPAMsanthell.dk

remove NOSPAM

Try this to see what the field gets changed to

SELECT Left(VareNummer, Len(VareNummer)-4) as NewVareNumber

Hi jubas>
THis works with the dB you sent

UPDATE billeder_gif SET billeder_gif.varenummer = Left([varenummer],Len([varenummer])-4);

jeg takke mange gang

selv tak, og god søndag